Enhancing the ER Model with Inegrity Methods
نویسنده
چکیده
Entity Relationship (ER) schemas include cardinality constraints, that restrict the dependencies among entities within a relationship type. The cardinality constraints have direct impact on application transactions, since insertions or deletions of entities or relationships might affect related entities. Application transactions can be strengthened to preserve the consistency of a database with respect to the cardinality constraints in a schema. Yet, once an ER schema is translated into a logical database schema, the direct correlation between the cardinality constraints and application transaction is lost, since the components of the ER schema might be decomposed among those of the logical database schema. We suggest to extend the Enhanced ER (EER) data model with integrity methods that take the cardinality constraints into account. The integrity methods can be fully defined by the cardinality constraints, using a small number of primitive update methods, and are automatically created for a given EER diagram. A translation of an EER schema into a logical database schema can create integrity routines by translating the primitive update methods alone. These integrity routines may be implemented as database procedures, if a relational DBMS is utilized, or as class methods, if an objectoriented DBMS is utilized.
منابع مشابه
Gasification of potato shoots: An experimental and theoretical investigation
A thermodynamic equilibrium model was developed to predict the gasification process in a bench-scale fluidized bed gasifier. Potato shoot (leaves and stems) was used as the feedstock of the gasifier. The experiments were done in five different gasification zone temperatures (650, 700, 750, 800 and 850°C), with a feeding rate of 0.166 kg/hour, and two equivalence ratios (ER: 0.2 and 0.25). T...
متن کاملDynamic Stability of Laminated Composite Plates with an External Smart Damper
The dynamic stability of a composite plate with external electrorheological (ER) damper subjected to an axial periodic load is investigated. Electrorheological fluids are a class of smart materials, which exhibit reversible changes in mechanical properties when subjected to an electric field. As a result, the dynamic behavior of the structure is changed. The ER damper is used for suppressing th...
متن کاملDesigning an Optimal Pattern of General Medical Course Curriculum: an Effective Step in Enhancing How to Learn
Introduction: In today's world with a vast amount of information and knowledge, medical students should learn how to become effective physicians. Therefore, the competencies required for lifelong learning in the curriculum must be considered. The purpose of this study was to present a desirable general medical curriculum with emphasis on lifelong learning. Methods: The present study was Mixe...
متن کاملComparative Protective Effects of Viola Spathulata, Urtica Dioica, and Lamium Album on Endoplasmic Reticulum (ER) Stress in Rat Stroke Model
Background: Pathological conditions, including ischemic stroke, are associated with severe Endoplasmic Reticulum (ER) stress that induces apoptosis and cell death. Herbal medicines are natural treatments with few side effects in such situations. Objectives: In the present study, we examined the probable neuroprotective effects of Viola spathulata, Lamium album, and Urtica dioica on splicing of...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1999